Osbourne was inducted for his solo career after previously being honored for his work with Black Sabbath